<?php

$data = array('msg' => null, 'type' => 'cpu','table' => 'cpus');

$data['search_fields'] = array(
  'cpu',
  'location',
  'spot',
  'department',
  'floor',
  'building',
);

$data['list_fields'] = array(
  'cpu_location_id',
  'cpu_warehouse_id'
);

$data['alias'] = array(
  '*, cpus.id',
  'CONCAT(spot,\' -  \',location) AS spot_location'
);

$data['joins'] = array(
  'locations',
  'buildings',
  'departments'
);

$data['join_fields'] = array(
  '`cpu_location_id`=`locations`.`id`',
  '`building_id`=`buildings`.`id`',
  '`department_id`=`departments`.`id`'
);

$data['order'] = 'building, department, floor, spot, cpu';

?>
